International Character Conversion Problem

I am having troubles inserting records with fields containing international characters. I'm using a MS SQL driver with an International language driver, yet some characters are still being converted. I'm curious if there is something I'm missing or not doing, or if it's just some sort of bug with the BDE. I've tried many different language drivers and alternative solutions (DBI calls, etc..). Any comments or suggestion will be welcome.

--Here is a sample of the code and the results:
    Table1.FieldByName('ITEM_TEXT').AsString :=                        
'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖïðñòóôöøúûüýþÿ';

   ... would be translated to 'AAAAÄÅÆÇEÉEEIIIIDÑOOOOOïdñòóôöoúûüypÿ'
cseanAsked:
Who is Participating?
 
urihConnect With a Mentor Commented:
If you're using PARADOX, try changing the Table Language to "Ascii-Ansi" (the 2nd one)
0
 
NandoCommented:
Have you tried to not use the International driver and use a standard one?
0
 
cseanAuthor Commented:
I have a tried a standard driver (ie. Ansi-Ascii) and a number of
international drivers.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
mheacockCommented:
Might it have something to do with the font you are trying to display the string in??  Just a guess.
0
 
mheacockCommented:
Are the international drivers using unicode?  Do you first have to specify the language in the driver, perhaps so it will know what section of the unicode character set to access??  Just another guess.
0
 
wmorrisCommented:
You need to make sure the MS-SQL server is set up with the correct language settings.   When BDE submits a statement to the SQL server, the SQL server might translate the data to it's native character set.  If your BDE language driver does not match the character set of the MS-SQL server, you will see this type of problem.

Also, try setting the language driver for your MSSQL alias to 'Western Europe ANSI'.

If that does not work, please supply the following details :
  -- what language version of Windows you are using
  -- what version of Windows (Win 95 or WinNT)
  -- what your MSSQL server is setup

0
 
urihCommented:
Glad I could have helped
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.