I got many problems with Khmer language in v5.
Please help!!!
1.Can not add product more then one in Khmer language
it always get message “This is already a Product with that name”
2.Search product is not recognize in Khmer language
3.Can not create Recipe for Inventory in Khmer language
That relates with your default SQL Server language. Normally it is defined while setting up SQL Server and it uses windows regional settings by default. I’ve searched for a solution but I think SQL Server does not support Khmer language as a default server language. So we should define it in table level.
For testing I’ve changed Name column language for MenuItems table by using this sql script.
ALTER TABLE dbo.MenuItems ALTER COLUMN Name
nvarchar(max)COLLATE Khmer_100_CI_AS NOT NULL;
… and tested how it appears in management studio.
So I can create multiple products (first 2)
… and search them.
As we can’t set Khmer as default database language we need to update all NVARCHAR columns one by one to support Khmer. You can find some scripts to update all columns at once.
While implementing multi language support for SambaPOS5 I’ll try to find a generic solution for that.
It was fine with v4, anyway thank for your support, hope you give me easy way to fix it soon.
Sorry for my bad English.
Between V4 and V5 there is no difference with how we read data from SQL server or how we check duplicate product names. As I’ve demonstrated the difference is on the SQL Server side.
Are they defiantly both running from the same SQL server?
I don’t use SQL Server. just install with Compact SQL 4.0
If i have v5 Local DB how can i convert to CE?
CE is much worse than local db you generally would not want to downgrade to that.
Because CE is work with my Language as you can see in screenshot
