[Info-Ingres] unicode enabled database

[Grant Croker]

On Wed, 2007-03-21 at 16:09 +0000, Roy Hann wrote:
> <martin.bowes at ctsu.ox.ac.uk> wrote in message 
> news:mailman.42.1174492732.20015.info-ingres at kettleriverconsulting.com...
> > Hi Everyone,
> >
> > Is there some simple query I can run which can tell me which
> > databases are unicode enabled, What normalisation form and what the
> > collation names are?
> >
> > I'm trying to track this down in the Opensource but I'm not getting
> > anywhere and doing that very slowly!
> 
> I wonder if that is known anywhere outside of config.dat?

its database specific and can be found using the dbmsinfo parameter
'unicode_normalization' as seen below:

For an NFD database...

grant at esva-suse:~> createdb -n unicode
Creating database 'unicode' . . .
 
  Creating DBMS System Catalogs . . . 
  Modifying DBMS System Catalogs . . . 
  Creating Standard Catalog Interface . . . 
  Creating Front-end System Catalogs . . . 

Creation of database 'unicode' completed successfully.
 
grant at esva-suse:~> sql unicode
INGRES TERMINAL MONITOR Copyright 2005 Ingres Corporation
Ingres 2006 Linux Version II 9.0.4 (int.lnx/104)NPTL login
Wed Mar 21 09:50:27 2007

continue
* select dbmsinfo('unicode_normalization')\g
Executing . . .


┌────────────────────────────────────────────────────────────────┐
│col1                                                            │
├────────────────────────────────────────────────────────────────┤
│NFD                                                             │
└────────────────────────────────────────────────────────────────┘
(1 row)
continue
* 

For an NFC database...
grant at esva-suse:~> createdb -i unicode
Creating database 'unicode' . . .
 
  Creating DBMS System Catalogs . . . 
  Modifying DBMS System Catalogs . . . 
  Creating Standard Catalog Interface . . . 
  Creating Front-end System Catalogs . . . 

Creation of database 'unicode' completed successfully.
 
grant at esva-suse:~> sql unicode
INGRES TERMINAL MONITOR Copyright 2005 Ingres Corporation
Ingres 2006 Linux Version II 9.0.4 (int.lnx/104)NPTL login
Wed Mar 21 09:49:33 2007

continue
* select dbmsinfo('unicode_normalization')\g
Executing . . .


┌────────────────────────────────────────────────────────────────┐
│col1                                                            │
├────────────────────────────────────────────────────────────────┤
│NFC                                                             │
└────────────────────────────────────────────────────────────────┘
(1 row)
continue
* 


regards

grant

-- 
Grant Croker, grantc at php.net
Software Engineer, Ingres - http://ingres.com
tel: +44 (0)1753 559505 UK / +34 676 518209 España