You are viewing a plain text version of this content. The canonical link for it is here.

Posted to torque-dev@db.apache.org by Adam Greene <ag...@romulin.com> on 2002/12/18 16:18:32 UTC

Do I need to do anything special to support french characters

I am having trouble with French characters coming out of the database funny.
I am using:

Torque 3.0B3
SQL Server 2000
Microsoft SQL Drivers (latest ones)

and anytime I put a french character (é for example) into a VARCHAR or TEXT
it gets written as the two characters (Â©).  Maybe this is a problem with
SQL Server, but if I put data in via the Enterprise Manager, it goes in
fine, comes out fine, but when I save it again, it goes funny.  (I've tried
using NVARCHAR and NTEXT and everything else I can think of).

On top of all this, I can get half web pages to display the french letters,
and half just show square boxes.  I hate multi-language!!

Has anyone else had this problem??