AW: my db doesn't selects any german umlaute any more - help needed

[Tiemo Hollmann TB]

Hi Ruslan,
thanks for answering

taking the original db from the standalone where it still works into the
current development or a newly created standalone, it doesn't works anymore,
so it isn't db related.

I used db.collation only once, when having created the db: get
VDataBase_CollationAttribute( gDBRef, "kStrength", "kSecondary" ) and didn't
changed it any more.

Very strange...

Thanks
Tiemo

> -----Ursprüngliche Nachricht-----
> Von: valentina-bounces at lists.macserve.net [mailto:valentina-
> bounces at lists.macserve.net] Im Auftrag von Ruslan Zasukhin
> Gesendet: Mittwoch, 14. Juli 2010 11:48
> An: valentina at lists.macserve.net
> Betreff: Re: my db doesn't selects any german umlaute any more - help
> needed
> 
> On 7/14/10 11:28 AM, "Tiemo Hollmann TB" <toolbook at kestner.de> wrote:
> 
> > Hello,
> >
> > V4REV_3:
> > I have an rev application with a valentina db running for over a
> year. After
> > having made some minor updates in my program, suddenly my selection
> on the db
> > returns no german Umlaute ä ö ü ß any more. I have nothing changed on
> the db
> > selection routines (at least not consciously).
> >
> > When opening the db with Valentina studio, the db is coded as UTF-16
> and I can
> > select any Umlaute without any problem in Studio.
> >
> > In my Rev program after having opend the db I set the IOEncoding to
> > ³Macintosh²
> > Displaying the whole content of the db in my rev program shows all
> Umlaute
> > correct. So the problem is only the select statement with Umlaute.
> >
> > My select statement looks very basic like this (e.g.): SELECT
> > begriffe.begriff_name FROM begriffe WHERE begriffe.begriff_name LIKE
> Œ%ä%¹
> > and the VDatabase_SQLSelectRecords(dbRef,pSQL) returns empty
> >
> > Same selection with Œ%a%¹ works fine
> >
> > Searching for two days already I am totally puzzeled. Perhaps I am
> overlooking
> > something very obvious. Perhaps the problem isn¹t in my code, but
> what could
> > have happened with the DB?
> >
> > Any ideas or hints where to look for are highly appreciated.
> 
> Point 1:
> 
> Decide if problem in the db or in app
>     I think you can create NEW fresh db
>     Add few records and test
> 
> 
> Point 2:
> 
>     may be changed db.Collation(Strength) parameter
> 
> --
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina