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
This is probably as good a place as any, but what exactly do you mean by "kana sensitive?" -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com
On Jul 8, 6:38 pm, "Linq Adams via AccessMonster.com" <u28780@uwe> wrote: > This is probably as good a place as any, but what exactly do you mean by > "kana sensitive?" 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
Dunno in the current version, but in older versions you set the collation when you created or compacted a database. (david) "Inquirer" wrote in message news:1deffe16-c1ea-4d83-94b4-ba11806a71fe@c58g2000hsc.googlegroups.com... On Jul 8, 6:38 pm, "Linq Adams via AccessMonster.com" <u28780@uwe> wrote: > This is probably as good a place as any, but what exactly do you mean by > "kana sensitive?" 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
On 12 Lip, 02:57, <david@epsomdotcomdotau> wrote: > Dunno in the current version, but in older versions you set > the collation when you created or compacted a database. mind providing a snippet of setting kana sensitive collation while doing these operations? or tell me how I can do it from GUI?
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) "Inquirer" wrote in message news:2efc9287-bbcd-45c4-8d4d-6f61699c7dd1@t54g2000hsg.googlegroups.com... > On 12 Lip, 02:57, <david@epsomdotcomdotau> wrote: > > Dunno in the current version, but in older versions you set > > the collation when you created or compacted a database. > mind providing a snippet of setting kana sensitive collation while > doing these operations? > or tell me how I can do it from GUI?
