Re: French characters

Alt255 schreef:
> I'm starting to think this is the issue -
> Here are the nls settings
> PARAMETER VALUE
> ------------------------------ ----------------------------------------
> NLS_LANGUAGE AMERICAN
> NLS_TERRITORY AMERICA
> NLS_CURRENCY $
> NLS_ISO_CURRENCY AMERICA
> NLS_NUMERIC_CHARACTERS .,
> NLS_CHARACTERSET US7ASCII
How in the world do you expect 7 bits to hold 8 bit data?!? You are using the extended ASCII characterset (ASCII, being short sighted american, does not allow accepted charactes), meaning the full 8 bits of a byte.

The fact you have a front end that inserts and retrieves them correctly means 2 characters are used in the database, some other codeing mechanism, or you simply are lucky.

My advise: if you're working in the western world, with clients that predominantly use Microsoft based O/S's for the forn end, choose WE8MSWIN1252 for database characterset, as well as client characterset!
Some clients may need WE8MSWIN1254, or another MSWIN codepage, but 99.9% of the times this setup works. Again, make sure, that at least the client side installation uses MSWIN1252! Database is less important than client (7bits, 8bits or multi byte issues left alone)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...