<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.E-MailFormatvorlage18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=DE link=blue vlink=purple>
<div class=WordSection1>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Having made some more
tests it shows that it isn’t affected by my program code.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>It must have
something to do with the Valentina environment or MacOS 10.5.8???<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>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<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>What I did on the
same machine:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Running the old
standalone version of my app: selecting Umlaute works ok<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Running the old
version of my app in my development environment: selecting Umlaute doesn’t
works<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Running the current
version of my app in my development environment: selecting Umlaute doesn’t
works<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Building a new
standalone of my current version: selecting Umlaute doesn’t works<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Copying an old
standalone bundle and copying manually the current standalone program file and
db file into the old bundle: selecting Umlaute works ok<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Running again the
INSTALL_VCOMPONENTS_V4REV_v3 “over” this working bundle: selecting
still works ok<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Having reinstalled
V4REV has nothing changed.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>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?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Is there any
component of the MacOS, which is copied into a standalone by the Valentina
Install which could make this behavior?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Any ideas what is
going on here are highly appreciated<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Tiemo<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Von:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
valentina-bounces@lists.macserve.net
[mailto:valentina-bounces@lists.macserve.net] <b>Im Auftrag von </b>Tiemo
Hollmann TB<br>
<b>Gesendet:</b> Mittwoch, 14. Juli 2010 10:28<br>
<b>An:</b> Valentina Liste senden<br>
<b>Betreff:</b> my db doesn't selects any german umlaute any more - help needed<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hello,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-US>V4REV_3:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>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).<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>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.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>In my Rev program after having opend the db
I set the IOEncoding to “Macintosh”<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>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.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>My select statement looks very basic like
this (e.g.): SELECT begriffe.begriff_name FROM begriffe WHERE
begriffe.begriff_name LIKE ‘%ä%’<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>and the
VDatabase_SQLSelectRecords(dbRef,pSQL) returns empty<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Same selection with ‘%a%’ works
fine<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>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?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Any ideas or hints where to look for are
highly appreciated.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Tiemo<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
</div>
</body>
</html>