 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / Ingres Topics / March 2007[Info-Ingres] unicode enabled database
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! Martin Bowes. -- Random Duckman Quote #27: Duckman - No doubt about it, the only solution left is to hickory smoke my brain to perfection with 10,000 volts of electricity. > Hi Everyone, > [quoted text clipped - 4 lines] > 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? Roy > > Hi Everyone, > > [quoted text clipped - 6 lines] > > 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@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@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@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@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  SignatureGrant Croker, grantc@php.net Software Engineer, Ingres - http://ingres.com tel: +44 (0)1753 559505 UK / +34 676 518209 España Good 'ole 'infodb' to the rescue: see the "Unicode enabled" and "Unicode normalization" field values. Mark R. Winston >> Hi Everyone, >> [quoted text clipped - 13 lines] > Info-Ingres@kettleriverconsulting.com > http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres Hi Roy et al, > I wonder if that is known anywhere outside of config.dat? I'm somewhat surprised to see that the only means of identifying the unicode bits are: 1. To quiz the specific database with: * select dbmsinfo(ucollation) * select dbmsinfo(unicode_normalization) 2. Just run infodb on the specific database and mine the output. I would have assumed that this detail would have made it as a column or a bit mask of something like the dbservice column of the iidatabase catalog in iidbdb.Failing to find it documented in there is why I was trawling the opensource. Although either of the above methods will satisfy my immediate requirements, which is the Disaster Recovery Planning side of things, I might keep playing in dmfjsp.c to see if there is something in there.... Hmm, does dbmsinfo trawl the databases config file? Actually I'm really just after excuses to play in the OpenSource. Its the best SandBox I've ever come across. Yes that is a CVS pun... Marty -- Random Duckman Quote #85: Ajax: Dad, what's the signal for when we're in tremendous danger and about to be captured? On Mar 21, 11:56 am, martin.bo...@ctsu.ox.ac.uk wrote: > 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? Good 'ole 'infodb' to the rescue: see the "Unicode enabled" and "Unicode normalization" field values. Mark R. Winston |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.