Re: [sqlite] codepages
"Sherief N. Farouk" schrieb im Newsbeitrag news:000301c97e09$2556f0f0$7004d2...@com... > > dear users > > I use sqlite for vb6, utf-8 database, > > when insert arabic data to database > > and search it with 'like' operator > > (within % syntax), return all records!!! > > Please help me... > > thanks I'm somehow missing the original message, so I'll reply here: Regarding VB6 - you could try out my wrapper (either the older dhSQLite or the newer version which comes in dhRichClient.dll) These VB6-based COM-Wrappers already contain appropriate Overrides for the Like-function, Upper(), Lower() and also the NoCase-Collation, where under the hood a fast UTF8->UCS2-BSTR- conversion is done - also included is an optimization for the overriden Like with regards to the usage of a predefined index for Like-queries of the form: SomeField Like 'abc%'. So normally that should work with no problems. Regards Olaf Schmidt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] codepages
Sherief N. Farouk writes: > > > dear users > > I use sqlite for vb6, utf-8 database, > > when insert arabic data to database > > and search it with 'like' operator > > (within % syntax), return all records!!! > > Please help me... > > thanks > > John Smith > > ___ > > Arabic, in general, is one hell of a language to deal with. Can you provide > some sample data, like a db file and sample query? > > - Sherief > See http://www.sqlite.org/lang_expr.html#like and http://www.sqlite.org/lang_corefunc.html#like You might wish to implement your own Arabic-aware like(). MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] codepages
> dear users > I use sqlite for vb6, utf-8 database, > when insert arabic data to database > and search it with 'like' operator > (within % syntax), return all records!!! > Please help me... > thanks > John Smith > ___ Arabic, in general, is one hell of a language to deal with. Can you provide some sample data, like a db file and sample query? - Sherief ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] codepages
dear users I use sqlite for vb6, utf-8 database, when insert arabic data to database and search it with 'like' operator (within % syntax), return all records!!! Please help me... thanks John Smith ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users