Re: collation issues.
Posted by: Savas Zorlu
Date: December 20, 2009 10:44AM

Thanks for the reply Rick,

Over the last 2 days, I have identified the problem correctly. Like you said it is not a collation issue. It is totally related to ODBC drivers. I thought it was ODBC 5.1 on the server but apparently the driver on the server is ODBC 3.51, and on my local copy the driver is ODBC 5.1.

So when I back it up on the server and restore it on my local database, the characters don't show up right. However, I installed ODBC 3.51 on my local computer and when I connect to database with ODBC 3.51 there are no problems.

So now, I need to figure out a way to be able to move my ODBC 3.51 written data to my ODBC 5.1 driver database.

Last night I thought about it while I was trying to sleep. Not sure if it would work but I assume, if I install ODB 5.1 on server and write a script to read all data using 3.51 connection and re-write it to same record using 5.1, it should be fixed. But its quite a task, I have over 30 tables with 200K records.

Options: ReplyQuote


Subject
Views
Written By
Posted
3965
December 18, 2009 04:00PM
2177
December 18, 2009 03:58PM
2716
December 19, 2009 09:04PM
Re: collation issues.
2375
December 20, 2009 10:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.