|Subject||Re: [Firebird-Java] Re: Strange character sets or.........u figure it out|
|Author||Rodolfo M. Raya|
On Thu, 2002-06-27 at 08:06, rrokytskyy wrote:Hi Roman,In the word "dreaptã" you have letter that does not belong to a charset you specified on connection. You have to specify the correct charset in property lc_ctype.
I have a problem with charsets in one database and maybe you can help me. This particular database was created using charset NONE, but there are 38 users adding data using different locale and they introduced characters from different character sets. I can't use the driver with this database because it only gives partial result sets.
To make a clearer example: some people wrote "Tucumán" under Windows 98 and when other users read it using Windows 95 they read "Tucumßn" . They don't care about the difference as long as they know the record is in the database.
The data was introduced using a program compiled with C++ Builder and at this moment there are more than 3.000.000 records that can't be reentered.
Could it be possible to leave character set as a really optional specification? If I can retrieve all the data using isql or Interclient without specifying charset, I should be able to do the same using the Type4 driver.
-- MAXPROGRAMS IBM Business Partner Microsoft MSDN Business Connection Partner rmraya@... http://www.maxprograms.com