![]() ![]()
I don't think this next page is relevant, but you'll have to investigate the links on it to see if they help You'll have to play with these possible ones to find out if they support your required characters msoEncodingISO88592CentralEurope WHEN POSSIBLE USE THE DEFAULT TEXT ENCODING IN REPLIES ISOISO 8859-16 Central, Eastern and Southern European languages (Albanian, Bosnian, Croatian, Hungarian, Polish, Romanian, Serbian and Slovenian, but also French, German, Italian Windows-1250 for Central European languages that use Latin script, (Polish, Czech, Slovak, Hungarian, Slovene, Serbian, Croatian, Bosnian, Romanian and Albanian) Since you are saving to text files, you will have to use an "encoding" that supports the Polish accent characters. _ Ken Sheridan, Cannock, England "Don't write it down until you understand it!" - Richard Feynman You'll need to find another way of exporting the query to the text file while retaining the accented characters. ![]() All email has a charset header which tells mail what encoding to actually use. ![]() In Mail, it should always say Automatic in Message > Text Encoding unless you manually change it. I tested this with some Polish characters, and found that the character is written to the text file unaccented. FireFox is different and when you look at View > Text Encoding you will see the encoding of the page you are viewing instead of Default. StrPrintList = strPrintList & strDelim & strQuote & _ StrQuote = IIf(blnQuoteText And (fld.Type = dbText Or fld.Type = dbMemo), """", "") StrPrintList = Mid$(strPrintList, Len(strDelim) + 1) StrPrintList = strPrintList & strDelim & qdf.Fields(n).Name If MsgBox("Overwrite " & strExportTo & "?", vbQuestion + vbYesNo, "Export Query") = vbYes ThenĮlseIf MsgBox("Append rows to " & strExportTo & "?", vbQuestion + vbYesNo, "Export Query") = vbNo Then ' blnHasFieldNames - Boolean - (optional) - True (default) to export field names as first line ' blnQuoteText - Boolean - True to enclose text or memo data in quotes ' strDelim - Text - delimiter character(s) to separate fields ' strExportTo - Text- path to file to export to '''If encoding or errors are specified, or universalnewlines is true, file objects for stdin, stdout and stderr are opened in text mode using the specified encoding and errors or the io.TextIOWrapper default.''' This is such a useful feature that it ought to be documented better, preferably with an example. ' strQuery - Text - name of query to be exported Optional blnHasFieldNames As Boolean = True) WHEN POSSIBLE USE THE DEFAULT TEXT ENCODING IN REPLIES CODEIn my demo the data from the query are written to the text file line by line by code in the following function:įunction ExportToText(strQuery As String, _ Setting the default Java character encoding. Its quite possible that using parameterized queries here will simply sort out your problem - as well as not being vulnerable to SQL injection attacks. The problem seems to be with the writing of the data to a text file which is then used as the data file for the Word mail merge. Ask Question Asked 11 years, 1 month ago. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |