Re: urgent:language-specific environment variables

"Oliver Stetskamp" <stetska@uni-muenster.de> writes: > Hi! > Ihave some trouble setting the right environment variables for the german > language specification. > i run an online informix-db version 7.2 and need the right variables to sort > things by the alphabet, including the german special characters (that "o" > with the two dots on top, for example). > did anybody experience similar problems and/or could provide the fitting > variables? > > i am thankful for any hint. > all the best, > > > o stetskamp Hello, 1. Set up CLIENT_LOCALE and DB_LOCALE environment variable to your locale. 2. Create your database. CLIENT_LOCALE and DB_LOCALE must be set before creating the database. 3. Use nchar and nvarchar instead of char and varchar. Ilia