#1 Re: mORMot 1 » Non ASCII characters in TSQLDBStatement.RowDocVariant » 2021-04-20 07:05:50

Hello

Actually two things did the trick
- update of mORMot and Zeos
- explicilty specifying required characterset for the connection.

I have to perform more tests, but so far it looks good

Thanks for all suggestions
Marcin

#2 Re: mORMot 1 » Non ASCII characters in TSQLDBStatement.RowDocVariant » 2021-04-16 14:58:17

I have checked same with UTF8 database and it is ok.
So following Arnaud's 'guessing' I'll try to set proper charset for db connection and see where I'll end up.

#3 Re: mORMot 1 » Non ASCII characters in TSQLDBStatement.RowDocVariant » 2021-04-15 18:32:48

Hello Arnaud
Latest mORMot (downloaded today) and Zeos 7.2.10 with latest patches (of 8th of April)
function UTF8ToWideChar from SynCommons returns 'us' string instead of 'usługa' (note the 3rd character in "usługa")

Any clues?

TIA
Marcin

#4 Re: mORMot 1 » Non ASCII characters in TSQLDBStatement.RowDocVariant » 2021-04-15 13:45:47

Can someone help me here, please

For unknow reason my project uses UTF8ToWideChar from ZEncoding instead of this one from SynCommons. It might be some settings I'm not aware of

TIA
Marcin

#5 Re: mORMot 1 » Non ASCII characters in TSQLDBStatement.RowDocVariant » 2021-04-15 08:02:02

Hi

I did some digging (debugging) and found guilty routine: it's UTF8ToWideChar from ZEncode unit called by UTF8ToSynUnicode from SynCommons.
I'm on Delphi 10.4, but finally I'd like to compile this project in FPC on linux.

TIA
Marcin

#6 mORMot 1 » Non ASCII characters in TSQLDBStatement.RowDocVariant » 2021-04-14 18:28:57

marcinb
Replies: 11

Hello

I have legacy firebird database  with code page WIN1250. Still on mORMot 1.18.
What should I do to get whole string ('usługa' instead of 'us') when getting column values via RowDocVariant method. Should I set some additional Zeos connection properties?
I've checked that TSQLDBStatement.FetchAllAsJSON method returns "unmodified" string...

Thanks in advance
Marcin

#7 Re: mORMot 1 » cross platfrom client - exceptions handling » 2017-11-03 17:14:30

Hi AB

Can you comment Tomek's suggestion?
Is it worth something? If so can you add to the 'official' sources?

Thanks,
Marcin

#8 Re: mORMot 1 » Delphi for Linux preview - what do you think? » 2016-08-30 16:19:54

@danielkuettner
I have separate machines for application server and database server. In my environment today it is Tomcat and Firebird SQL server, in near future another machine will be set up explicitly for mORMot server for use with mobile application.
Sorry for misleading post.

#9 Re: mORMot 1 » Delphi for Linux preview - what do you think? » 2016-08-30 13:45:56

@danielkuettner

I would separate DB server from mORMot server, like I have today with Tomcat and DB server. Then you can still have mORMot on Linux  and DB of your choice.

#10 Re: mORMot 1 » OFF-TOPIC: Merry christmas... » 2014-12-25 18:53:31

Wesołych Świąt Bożego Narodzenia i szczęśliwego Nowego Roku 2015...

... to all happy Mormot developers and users

Marcin

#11 mORMot 1 » mORMot Framework on Linux via FPC » 2014-05-15 08:09:59

marcinb
Replies: 1

Hi

There is the item in the roadmap that regards cross-platform compilation using FPC.
What are the plans for that "feature". Two years ago it had quite good priority. How does it look today?

I'm going to start my "adventure" with this framework to create middle-tier for mobile applications, so lots of work ahead of me and Linux support at this moment is not that important. But for one particular project I will need Linux support for server side.

Thanks
Marcin

Board footer

Powered by FluxBB