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

[Tiemo Hollmann TB]

Having made some more tests it shows that it isn’t affected by my program
code.

It must have something to do with the Valentina environment or MacOS
10.5.8???

It also can’t be some general missing of the db- drivers or something like
this, because the db opens and all other functions run fine

 

What I did on the same machine:

Running the old standalone version of my app: selecting Umlaute works ok

Running the old version of my app in my development environment: selecting
Umlaute doesn’t works

Running the current version of my app in my development environment:
selecting Umlaute doesn’t works

Building a new standalone of my current version: selecting Umlaute doesn’t
works

Copying an old standalone bundle and copying manually the current standalone
program file and db file into the old bundle: selecting Umlaute works ok

Running again the INSTALL_VCOMPONENTS_V4REV_v3 “over” this working bundle:
selecting still works ok

Having reinstalled V4REV has nothing changed.

 

Can there be any influence of any MacOS update on the Valentina functions,
which avoid Valentina of handling the encoding correctly? And this only for
newly build Standalones, but not old packages?

Is there any component of the MacOS, which is copied into a standalone by
the Valentina Install which could make this behavior?

Any ideas what is going on here are highly appreciated

Thanks

Tiemo

 

Von: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] Im Auftrag von Tiemo Hollmann
TB
Gesendet: Mittwoch, 14. Juli 2010 10:28
An: Valentina Liste senden
Betreff: my db doesn't selects any german umlaute any more - help needed

 

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.

Thanks

Tiemo

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20100714/0be4ce98/attachment.html>