Re: Newbie question
On Wed, 2 Feb 2005 14:32:20 -0000, Doug Lawry wrote: > As "garyok" says, Server Studio does not work with Standard Engine (SE), which > in any case has now largely been superseded by Informix Dynamic Server (IDS) and > does not have the full functionality, so you should download IDS-9.4-UC2 from > IIUG. I did that. After some tweaking it worked just fine. Thank you bouth. Next question: Where do I change coding page of my databases? I want to use Unicode, 1250 or ISO-8859-2 (one of those). Unicode preferably. Also where do I change date format? Default is YYYY.MM.DD but I want DD.MM.YYYY.
bariole wrote: > Next question: > Where do I change coding page of my databases? I want to use Unicode, 1250 > or ISO-8859-2 (one of those). Unicode preferably. > Also where do I change date format? Default is YYYY.MM.DD but I want > DD.MM.YYYY. The character set is determined during create database and cannot be changed. The environment variable DB_LOCALE must be set prior to create the database. If DB_LOCALE is not set then database is created with en_US locale (std 8 bit ASCII). You can check the database's locale using dbaccess->database->info->nls or "select site from systables where tabid=91". If you want to use unicode (UTF-8), read the GLS manual and the release notes for IDS 9.40 The data type DATE is internally an integer. Conversion of DATE to and from text strings is cntrolled by CLIENT_LOCALE or DBDATE environment variables. To use the DD.MM.YYYY format set DBDATE="DMY4."
On Fri, 04 Feb 2005 12:05:36 +0100, Claus Samuelsen wrote: > bariole wrote: >> Next question: >> Where do I change coding page of my databases? I want to use Unicode, 1250 >> or ISO-8859-2 (one of those). Unicode preferably. >> Also where do I change date format? Default is YYYY.MM.DD but I want >> DD.MM.YYYY. > > The character set is determined during create database and cannot be > changed. The environment variable DB_LOCALE must be set prior to create > the database. If DB_LOCALE is not set then database is created with > en_US locale (std 8 bit ASCII). You can check the database's locale > using dbaccess->database->info->nls or "select site from systables where > tabid=91". > > If you want to use unicode (UTF-8), read the GLS manual and the release > notes for IDS 9.40 > > The data type DATE is internally an integer. Conversion of DATE to and > from text strings is cntrolled by CLIENT_LOCALE or DBDATE environment > variables. > > To use the DD.MM.YYYY format set DBDATE="DMY4." That was all I needed. Thaks.