update query with greek characters

I want to do an update query on a table I imported to change all records to
propercase. In my table I have a lot of greek names (in the greek alphabet,
just the default font using the greek letter of that font) but when I run the
query all greek letters are replaced by questionmarks, meaning that the
fields containing greek words are converted to questionmarks but not the
english ones.
As this is a long table I want to avoid doing it all by hand.
Can someone help me?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200704/1

On Mon, 30 Apr 2007 19:19:13 GMT, "greeknl via AccessMonster.com" u30909@uwe
wrote:

I want to do an update query on a table I imported to change all records to
propercase. In my table I have a lot of greek names (in the greek alphabet,
just the default font using the greek letter of that font) but when I run the
query all greek letters are replaced by questionmarks, meaning that the
fields containing greek words are converted to questionmarks but not the
english ones.
As this is a long table I want to avoid doing it all by hand.
Can someone help me?

Well, you can limit the StrConv() to only Latin letters by using a criterion
of

LIKE "*[A-Z]*"

or, better,

NOT LIKE "*[" & Chr(894) & "-" Chr(974) & "]*"

which is the range of Greek characters (from my character map utility).

It appears that each upper-case Greek letter can be converted to lower case by
adding 32 to its ASCII value, or vice versa by subtracting. Using this info
one could write a VBA function GkStrConv. I'm not sure what to do with "tonos"
or "dialytika" so I won't comment on those... but you may be able to get some
ideas with Start... All Programs... Accessories... System Tools... Character
Map.

John W. Vinson [MVP]

Thanks a lot
I will give it a try.
I hope it is a easy task to combine the strconv with your criterion

John W. Vinson wrote:
I want to do an update query on a table I imported to change all records to
propercase. In my table I have a lot of greek names (in the greek alphabet,
[quoted text clipped - 4 lines]
As this is a long table I want to avoid doing it all by hand.
Can someone help me?

Well, you can limit the StrConv() to only Latin letters by using a criterion
of

LIKE "*[A-Z]*"

or, better,

NOT LIKE "*[" & Chr(894) & "-" Chr(974) & "]*"

which is the range of Greek characters (from my character map utility).

It appears that each upper-case Greek letter can be converted to lower case by
adding 32 to its ASCII value, or vice versa by subtracting. Using this info
one could write a VBA function GkStrConv. I'm not sure what to do with "tonos"
or "dialytika" so I won't comment on those... but you may be able to get some
ideas with Start... All Programs... Accessories... System Tools... Character
Map.

John W. Vinson [MVP]

--
Message posted via http://www.accessmonster.com

On Tue, 01 May 2007 18:34:36 GMT, "greeknl via AccessMonster.com" u30909@uwe
wrote:

Thanks a lot
I will give it a try.
I hope it is a easy task to combine the strconv with your criterion

I fear it won't be!!!

StrConv() will convert Latin alphabet text. You will have to rewriter
StrConv() for it to handle Greek. I'm sure it can be done, I'm guessing it may
have *been* done, but I don't know where and it's more code than I'd want to
try to write!

John W. Vinson [MVP]

I came accross the function Ucase() which changes strings to Uppercase.
I hope this will work also in the query because in VBA it worked fine.

Again thanks for all the help

John W. Vinson wrote:
Thanks a lot
I will give it a try.
I hope it is a easy task to combine the strconv with your criterion

I fear it won't be!!!

StrConv() will convert Latin alphabet text. You will have to rewriter
StrConv() for it to handle Greek. I'm sure it can be done, I'm guessing it may
have *been* done, but I don't know where and it's more code than I'd want to
try to write!

John W. Vinson [MVP]

--
Message posted via http://www.accessmonster.com