Re: Sql server to xml string with encoding

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Per Bolmstedt (per.bolmstedt_at_framINGENrEKLAMtACKfab.se)
Date: 06/22/04


Date: Tue, 22 Jun 2004 15:44:59 +0200


"Jon Skeet [C# MVP]" <skeet@pobox.com> wrote:

> It doesn't matter how the data is stored in the database - by the
> time it's been fetched from the database, it's just Unicode text,
> assuming you've got it in text fields in the database.

But to convert the database text to Unicode, either the reader or the
database must know how the database data is formatted, right?



Relevant Pages

  • Re: VarChar VS. nVarChar
    ... Unless if you are already in the case of working in a near saturation level, ... will be easy or not later to change from ANSI to Unicode. ... database and cut in a half its performance. ... increase in storage and a performance decrease of about 10%. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MySQL Insert Unicode Problem
    ... I'm trying to insert some data from an XML file into MySQL. ... The database server has to support Unicode, ...
    (comp.lang.python)
  • Re: CDatabase and UNICODE problem
    ... Because of language character problems I changed my project to UNICODE. ... But I am really stuck with this database issues. ... But CDaoDatabase supports UNICODE queries. ...
    (microsoft.public.vc.mfc)
  • Unicode/utf-8 data in SQL Server
    ... I'm working with a MS SQL Server database created by a program from a ... fine US company who seems to have gotten run over by the Unicode truck. ... file created from a report to import in Excel and is getting an ... the database, accumulate the entire result text as a big unicode string ...
    (comp.lang.python)
  • Re: Dealing with "funny" characters
    ... database; ... to be stored in Unicode: ... print "utf-8 is not unicode" ... So some encodings are defined that are capable of encoding _ALL_ unicode codepoints. ...
    (comp.lang.python)