asked on

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ÿ'

Nando

Have you tried to not use the International driver and use a standard one?

csean

ASKER

I have a tried a standard driver (ie. Ansi-Ascii) and a number of
international drivers.

mheacock

Might it have something to do with the font you are trying to display the string in?? Just a guess.

mheacock

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.

wmorris

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

ASKER CERTIFIED SOLUTION

urih

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

urih

Glad I could have helped