Mu Emu S8EP3 db edit case sensitive

[nemeth]

Hello

we managed to set the memb__id success



help how I can turn it on case sensitive memb__pwd not succes

even if I set it up Latin1_General_CS_AS But it's not working.

pls help

[MentaL]

[Cookie Shief]

Run this Query

SELECT memb__pwd
FROM MEMB_INFO
WHERE memb__pwd COLLATE Latin1_General_CS_AS = 'casesearch'

Then

ALTER TABLE MEMB_INFO
ALTER COLUMN memb__pwd VARCHAR(10)
COLLATE Latin1_General_CS_AS

[nemeth]

js surce problem while i managed to fix it :)
now

19:30:44 [QueryManager] State (42000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CS_AS" and "Latin1_General_CI_AS" in the equal to operation.