[Info-Ingres] unicode enabled database

[Grant Croker]

Hi Marty,

 

If I am reading the code right the information is read from the session
control block. The dbmsinfo() call just reads the relevant attribute and
relays the response. See back/scf/scu/scuisvc.c (search for
SCI_UNICODE_NORM). The dbmsinfo() gubbins are setup in
back/scf/scd/scdinit.c ( again search for SCI_UNICODE_NORM or
UNICODE_NORMALIZATION).

 

I do not know enough to say how scb->scb_sscb.sscb_ics.ics_dbserv gets
populated - perhaps one of my colleagues could enlighten me/us.

 

Regards,

 

grant

 

________________________________

From: info-ingres-bounces at kettleriverconsulting.com
[mailto:info-ingres-bounces at kettleriverconsulting.com] On Behalf Of
martin.bowes at ctsu.ox.ac.uk
Sent: 22 March 2007 11:06
To: roy Hann
Cc: info-ingres at kettleriverconsulting.com
Subject: Re: [Info-Ingres] unicode enabled database

 

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?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070322/30b45b80/attachment.html