shelbyinfotech
asked on
Unicode to Ascii Oracle 10g
I have a view created in Oracle 10g that outputs one field, which is returned Unicode.
My clients have old ODBC drivers that do not recognize Unicode.
How do I convert this field to ASCII ?
My clients have old ODBC drivers that do not recognize Unicode.
How do I convert this field to ASCII ?
ASKER
All the data will be ASCII
What does your view code look like?
>>All the data will be ASCII
Then why can't you just select it? an 'A' in a unicode database should be an 'A' when you select it out.
I agree with awking00, let's take a look at your view code.
Then why can't you just select it? an 'A' in a unicode database should be an 'A' when you select it out.
I agree with awking00, let's take a look at your view code.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Once selected in SQL Plus...yeah I get the data...I can't get it from the old odbc driver that msaccess is using
Try setting NLS_LANG on the Client's client side as franckpachot suggested.
ASKER
Where would that be ? In the Oracle Client or ODBC ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I doubt this will solve the issue since the Unicode is likely coming from the default database characterset but wanted to throw it out there just in case it will trick the ODBC drivers.
The CONVERT sql function:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions034.htm#SQLRF00620
The CONVERT sql function:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions034.htm#SQLRF00620
ASKER
Thanks ....just had to find WHERE in the registry...btw it was in ORACLE_ALL_HOMES
sqlplus and odbc should not use the same NLS_LANG as DOS and Windows codepage are different.
Are you sure that you have the right encoding in the database ? You should use DUMP function to check.
Maybe the data was entered with an incorrect setting.
Are you sure that you have the right encoding in the database ? You should use DUMP function to check.
Maybe the data was entered with an incorrect setting.
Can you provide some sample data and expected results?