Comments by Dennis C. Dietrich

Dennis C. Dietrich 13-Aug-13 16:05pm View

The OP has extended ASCII strings in a database which in itself has nothing to do with VB6 (getting into that state probably did). I can't know what the OP should do but the two options are keeping the database as is and converting to Unicode on reads and to ASCII on writes. Or make a schema change, convert everything in one go and then just keep using Unicode. I would tend to the latter but without more details I can't say which approach makes more sense.

As for "Unicode", you are mistaken. Unicode starting with version 2.0 simply defines code points which is really nothing more than a list of characters and their numerical value in Unicode. You still have to encode these somehow for storage in memory, files, etc. (the code space is 21-bit). UTF-16 is one of those encodings (see http://www.unicode.org/faq/utf_bom.html).

Dennis C. Dietrich 10-Aug-13 3:10am View

Yep. Why don't you repost your comment as a solution? :)

Dennis C. Dietrich 7-Aug-13 8:04am View

Dear Mr. Selvanayagam,

We are terribly sorry that you haven't received your last payment for answering questions on this site. Please post your full name and address, date of birth, social security number, all account numbers (checking, savings, credit cards, Starbucks rewards card, etc.), vehicle identification number of your car(s), all user names and passwords you currently use as well as a full list of questions answered by you in the past month. We will wire your payment as soon as we receive this information. Again, we apologize for the inconvenience.

Best regards
Accounting Department

Comments by Dennis C. Dietrich (Top 3 by date)