Hello Mark, Tuesday, October 30, 2018, 8:20:51 AM, you wrote:
> On 29-10-2018 02:06, Helen Borrie hele...@iinet.net.au > [firebird-support] wrote: >> Character set NONE is a bare-bones ASCII set and does not provide >> intrinsic support for any characters beyond the 128 characters that >> provide the US-Ascii upper and lower case, numerals and the basic >> diacritic symbols. You can store anything in charset NONE but nothing >> in the least useful can be done with those incompatible characters. > NONE only means store the bytes accepted and return them as is, and if a > connection character set is specified, try to convert the stored bytes > to that character set. That much is true - but only if the first 128 characters of the incoming set are compatible with those of US-Ascii. > It does not mean or assume ASCII at all. "At all" is too sweeping. The recognised alpha characters in NONE are the unaccented a-z and A-Z of us-Ascii. Hence, if you are feeding in strings that involve only those characters, you can UPPER and LOWER them, and concatenate them. > It just > happens that most (all?) Firebird supported character sets (including > UTF-8) use ASCII as the base for the first 128 characters. Considering all supported character sets, not "most", not "all". It's only true of character sets that can recognise those 7-bit characters and can read the bytes in left-to-right order. So -- most (if not all) Western character sets, few if any Eastern ones that are stored in NONE. Helen --- This email has been checked for viruses by AVG. https://www.avg.com