At 10:07 AM 11/11/2003 +0200, you wrote:

>Sorry about should have probably have said. That I use the BDE to access my
>paradox tables. I have found the error. It occurred because of record 183
>which had a field value of the following :"Réunion"
>I hope you can see in this email that the 2nd letter is an e with a line on
>it. When recreated my table which had previously the ASCII characters set
>set to none it worked without problems. I am still not sure why ASCII wont
>take the "é" Alt-0233. Used following statement : DEFAULT CHARACTER SET
>ASCII ; Perhaps there is a bigger character set than ASCII. Because I am
>not sure if NONE will suffice.

No, NONE will not suffice if you are storing accented characters. US ASCII
won't do either, because it's a subset that doesn't know about those
characters. Possibly ISO8859_1 will do it for you. You really should have
created the database with a default character set; and you would then need
for your clients to connect to it using that character set as well.

Why not post a question with the words "Character set" in the
subject? Then one of the Europeans will notice it and give you advice
about the best choice for the data you have to store.

heLen