My SQL Server database has some tables with NVarchar fields to allow multiple languages in the same database.
But i've found in your documentation the following limitation:
Is there a possibility of this feature is available soon?
If you want to support all unicode characters, you need to create an UltraLite database that uses utf8 data encoding (collation sequence is independant of the encoding).
For example: ulload - c --utf8_encoding=1 ulinit --utf8_encoding=on
conn = ULDatabaseManager::CreateDatabase( "DBF=mydb.udb", "utf8_encoding=on" );
The default as of 12.0.0 is to create a database with utf8 encoding.
When defining the remote (UltraLite) tables, make sure that you allocate 3 times the number of bytes that the nvarchar(c) column is defined as to ensure data is not truncated. That is if the consolidated db has NVARCHAR(10), the UltraLite db should have CHAR(30) as the corresponding column.
As for future support of any feature, we cannot comment. However we will note your request for this feature. Thanks for using UltraLite and for providing feedback.