JET + kana sensitive

I

Inquirer

Hello,
I'm probably wrong here, but I couldn't find a suitable group:(
does anybody know how to make a JET database kana sensitive?
Thank you in advance
Konrad
 
L

Linq Adams via AccessMonster.com

This is probably as good a place as any, but what exactly do you mean by
"kana sensitive?"
 
I

Inquirer

This is probably as good a place as any, but what exactly do you mean by
"kana sensitive?"
Click to expand...
all right:
in SQL Server you can set "kana sensitive" by setting a collation with
the _KS suffix,
for example: Latin1_General_CI_AS_KS_WS.
however, I have no idea how I could set such a collation for a JET db.
Greetings
K
 
G

Guest

Dunno in the current version, but in older versions you set
the collation when you created or compacted a database.

(david)

This is probably as good a place as any, but what exactly do you mean by
"kana sensitive?"
Click to expand...
all right:
in SQL Server you can set "kana sensitive" by setting a collation with
the _KS suffix,
for example: Latin1_General_CI_AS_KS_WS.
however, I have no idea how I could set such a collation for a JET db.
Greetings
K
 
I

Inquirer

Dunno in the current version, but in older versions you set
the collation when you created or compacted a database.
Click to expand...
mind providing a snippet of setting kana sensitive collation while
doing these operations?
or tell me how I can do it from GUI?
 
G

Guest

application.DBEngine.CompactDatabase srcname,dstname,dbLangArabic

I've never used anything other than the default, so I can't tell
you if the syntax in some versions of the Help file is correct,
or if the alternative syntax suggested by some versions of
Auto Quick Info is correct.

(david)
 
Top