mORMot Open Source

johnnysynop

Member

Registered: 2018-07-01

Posts: 29

TestSql fails at utf8

Why it fails, any ideas? (red entry) ?
Compiled under 10.2

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,224

Website

Re: TestSql fails at utf8

I guess your code page is not 1250 - I guess this is the reason why.
Sorry for the problem.

johnnysynop

Member

Registered: 2018-07-01

Posts: 29

Re: TestSql fails at utf8

I guess your code page is not 1250 - I guess this is the reason why.
Sorry for the problem.

Thanks but does not worked still , I tried to set project options compiler codepage 1250 and 852 like my "chcp" shows
Always have this error, any other ideas?

edwinsn

Member

Registered: 2010-07-02

Posts: 1,215

Re: TestSql fails at utf8

This is the issue I couldn't find a solution yet, when running the mORMot tests, although I'm using mORMot without any issues, the amount of failures still frightens me.

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,224

Website

Re: TestSql fails at utf8

It is 1252 (Western Europe) which is expected...

And it is not the project code page (I don't even know what this setting is - I guess it is about source code files code page), but the whole Windows code page:
Open Windows Control Panel
Select Region and Language
Click on the Administrative tab
Under Language for non-Unicode programs, click on Change System Locale
Choose the locale
Click OK
Restart

So not something you expect to do just for testing...

johnnysynop

Member

Registered: 2018-07-01

Posts: 29

Re: TestSql fails at utf8

@ab
Thanks
I don't see such settings in my Windows 10.
I see bigger problem used today build of your framework and run tester under XP SP3 look:
There I don't see UTF-8 problems but other issue like below.
Please take a look closer at your tester app.

Last edited by johnnysynop (2018-10-08 12:32:15)

pvn0

Member

From: Slovenia

Registered: 2018-02-12

Posts: 210

Re: TestSql fails at utf8

If you don't know how to get to Control Panel in Windows 10, just type Control Panel in windows search (WIN + Q) or windows run (WIN + R).

Btw you provide no information about your system so I don't know why you think anyone can solve this for you. If you have IDE installed in XP you can debug it, if not you can use TSynLog to record exception stacktrace to file and it will tell you at exactly which line exception happens( or use 3rd party like Eurekalog).

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,224

Website

Re: TestSql fails at utf8

The A/V is due to Windows XP not able to download correctly some reference JSON via https.
You have to download the files manually and put them in your executable folder.

XP is clearly deprecated and should not be used anymore.

But with the right json files, there is no problem (but a MsAccess/Jet issue, which is due to XP itself).
https://gist.github.com/synopse/dccddcf … abf1376bc7

johnnysynop

Member

Registered: 2018-07-01

Posts: 29

Re: TestSql fails at utf8

@ab, thank you clear now.

@pvn0, I don't know if you wanted to be pointed or you really was trying to explain me hwo to open ctrl panel, really I know how to make it : )
I have just expected at quick, some code pages instead of countries list and there I was wrong, yes after changing to English, problem disappeared.

@ab, maybe it's time to switch to some VCL based form and memo for example instead of console ?

pvn0

Member

From: Slovenia

Registered: 2018-02-12

Posts: 210

Re: TestSql fails at utf8

@pvn0, I don't know if you wanted to be pointed or you really was trying to explain me hwo to open ctrl panel, really I know how to make it : )
I have just expected at quick, some code pages instead of countries list and there I was wrong, yes after changing to English, problem disappeared.

That's great, I assumed that because of your answer to ab. Just trying to help. A lot of people think the old Control Panel does not exist anymore in Windows 10 because when you usually do a search for an option like Language you will be redirected to the bastardized version of the control panel which is an UWP app called PC Settings.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,224

Website

Re: TestSql fails at utf8

Console is just fine, it is cross-platform and cross-compiler, and it is easy to redirect to a text file for continuous integration scripts.
A VCL app would be perhaps more beautiful, but much less practical.