Subscribe to this thread
Home - General / All posts - Transform-Make Upper Case Problem with non-Latin Characters
geozap
264 post(s)
#14-Nov-14 12:58

I have a text column with lowercase text with Greek characters. I want to make it upper case but the Transform-Make Upper Case transformation on the table doesn't work. Isn't the transformation supposed to work with non-Latin texts too?

I tried both with Unicode and ANSI column text type.

Gustavo Palminha

1,010 post(s)
#14-Nov-14 13:05

Isn't the transformation supposed to work with non-Latin texts too?

I think it should work with non latin text too.


Stay connected:

Linkedin >> http://www.linkedin.com/in/gustavopalminha

Twitter >> http://twitter.com/gustavopalminha

Other >> http://www.spatialmentor.com

geozap
264 post(s)
#15-Nov-14 09:31

Make Lower Case also doesn't work.

I post a map file to show the problem. I don't know if people that don't have Greek fonts will be able to read the text.

Attachments:
Case problem.map

tjhb
10,094 post(s)
#16-Nov-14 00:40

(I can't.)

KlausDE

6,410 post(s)
#16-Nov-14 08:08

I can't see Greek fonts, too. But with our german special characters the VBScript functions UCase() and LCase() work as do the SQL functions SELECT UPPER([Text]), LOWER([Text]). This ist true for Unicode Text as well a ANSI Text with codepage=0 (local settings).

If I set the input colum to type ANSI and Language to codepage 65001 (UTF-8) SQL functions work correct while VBScript functions fail.


Do you really want to ruin economy only to save the planet?

geozap
264 post(s)
#16-Nov-14 15:59

I don't know if this has to do with my problem with Upper/Lower Case transformation , but I have problems with Greek text in Script components too. In scripts when I write some text in Greek (to comment something), instead of getting Greek characters I get characters such as "letter a with grave accent" etc. But in Comments components or with text in table columns data I have no problem with Greek text.

KlausDE

6,410 post(s)
#16-Nov-14 17:47

Manifold is not localized. So as long as it uses high level Windows functions and controls Windows takes care of the localization. But pur manifold code as used in the Transform Toolbar input does not work this way. With our komma as decimal delimiter I always have to check, where to use komma and where colon.


Do you really want to ruin economy only to save the planet?

geozap
264 post(s)
#17-Nov-14 15:50

Anyway, since I put lowercase letters in a field and they don't transform to uppercase as they are supposed, this is a bug, isn't it?

Manifold User Community Use Agreement Copyright (C) 2007-2021 Manifold Software Limited. All rights reserved.