[Mono-list] Problem with MySql.Data.MySqlClient.MySqlConnection.Open() or System.Text.Encoding.GetEncoding()

Reggie Burnett rykr@comcast.net
Wed, 17 Nov 2004 08:01:44 -0600


This is a multi-part message in MIME format.

------=_NextPart_000_0176_01C4CC7B.B573B7C0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

I think this has been fixed in Mono, but I'm not sure.
 
  _____  

From: mono-list-admin@lists.ximian.com
[mailto:mono-list-admin@lists.ximian.com] On Behalf Of Joshua Brickel
Sent: Wednesday, November 17, 2004 11:53 AM
To: mono-list@lists.ximian.com
Subject: [Mono-list] Problem with
MySql.Data.MySqlClient.MySqlConnection.Open() or
System.Text.Encoding.GetEncoding()
 
Hi,

I'm not sure if this is a problem with the MySql library or with a System
library.  But what appears to be happenning is that  the Method
MySql.Data.MySqlClient.MySqlConnection.Open() appears to be calling
System.Text.Encoding.GetEncoding("latin1"); The reason I say this is that
the error I get when trying to open a database is:

 Unhandled Exception: System.NotSupportedException: Encoding name `latin1'
not supported
in [0x000fe] (at
/opt/src2/mono-all/1.0.4/mcs-1.0.4/class/corlib/System.Text/Encoding.cs:446)
System.Text.Encoding:GetEncoding (string)

And indeed if I run just the line System.Text.Encoding.GetEncoding("latin1")
I get the same error of:  
Unhandled Exception: System.NotSupportedException: Encoding name `latin1'
not supported
in [0x000fe] (at
/opt/src2/mono-all/1.0.4/mcs-1.0.4/class/corlib/System.Text/Encoding.cs:446)
System.Text.Encoding:GetEncoding (string)

Now I figure this is a problem either with System.Text or with the
Mysql.Data Library.  But I can not tell unless I can find documentation of
whether or not System.Text should support the string value of "latin1".

Does anyone know where the requirments for System.Text are kept?  

In addition, apparently I will not be able to get this library to work with
my MySql database unless I change the language encoding.  Does anyone have
any experience on which charchter set is common to both DotNet and MySql?

Finally, does anyone know to Whom do I contact to see if I can be of any
help in the area of documentation?

Regards,

Joshua




------=_NextPart_000_0176_01C4CC7B.B573B7C0
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 11">
<meta name=3DOriginator content=3D"Microsoft Word 11">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C4CC7B.AE1A9D40">
<link rel=3DEdit-Time-Data href=3D"cid:editdata.mso">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:ValidateAgainstSchemas/>
  <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
  <w:IgnoreMixedContent>false</w:IgnoreMixedContent>
  <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:LatentStyles DefLockedState=3D"false" LatentStyleCount=3D"156">
 </w:LatentStyles>
</xml><![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;
	mso-font-charset:0;
	mso-generic-font-family:swiss;
	mso-font-pitch:variable;
	mso-font-signature:1627421319 -2147483648 8 0 66047 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";
	color:black;}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;
	text-underline:single;}
span.EmailStyle17
	{mso-style-type:personal-reply;
	mso-style-noshow:yes;
	mso-ansi-font-size:10.0pt;
	mso-bidi-font-size:10.0pt;
	font-family:Arial;
	mso-ascii-font-family:Arial;
	mso-hansi-font-family:Arial;
	mso-bidi-font-family:Arial;
	color:navy;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
 /* Style Definitions */=20
 table.MsoNormalTable
	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0in 5.4pt 0in 5.4pt;
	mso-para-margin:0in;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";
	mso-ansi-language:#0400;
	mso-fareast-language:#0400;
	mso-bidi-language:#0400;}
</style>
<![endif]--><!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body bgcolor=3Dwhite lang=3DEN-US link=3Dblue vlink=3Dpurple =
style=3D'tab-interval:.5in'>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I think this has been fixed in =
Mono, but I&#8217;m
not sure.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div style=3D'border:none;border-left:solid blue 1.5pt;padding:0in 0in =
0in 4.0pt'>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
color=3Dblack face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:windowtext'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>

</span></font></div>

<p class=3DMsoNormal><b><font size=3D2 color=3Dblack face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma;color:windowtext;font-weight=
:bold'>From:</span></font></b><font
size=3D2 color=3Dblack face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;
color:windowtext'> mono-list-admin@lists.ximian.com
[mailto:mono-list-admin@lists.ximian.com] <b><span =
style=3D'font-weight:bold'>On
Behalf Of </span></b>Joshua Brickel<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, November =
17, 2004
11:53 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
mono-list@lists.ximian.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> [Mono-list] =
Problem with
MySql.Data.MySqlClient.MySqlConnection.Open() or
System.Text.Encoding.GetEncoding()</span></font><font =
color=3Dblack><span
style=3D'color:windowtext'><o:p></o:p></span></font></p>

</div>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>Hi,<br>
<br>
I'm not sure if this is a problem with the MySql library or with a =
System
library.&nbsp; But what appears to be happenning is that&nbsp; the =
Method </span></font><font
color=3D"#3366ff"><span =
style=3D'color:#3366FF'>MySql.Data.MySqlClient.MySqlConnection.Open()</sp=
an></font>
appears to be calling <font color=3D"#3366ff"><span =
style=3D'color:#3366FF'>System.Text.Encoding.GetEncoding(&quot;latin1&quo=
t;);
</span></font>The reason I say this is that the error I get when trying =
to open
a database is:<br>
<br>
&nbsp;Unhandled Exception: System.NotSupportedException: Encoding name =
`latin1'
not supported<br>
in [0x000fe] (at
/opt/src2/mono-all/1.0.4/mcs-1.0.4/class/corlib/System.Text/Encoding.cs:4=
46)
System.Text.Encoding:GetEncoding (string)<br>
<br>
And indeed if I run just the line <font color=3D"#3366ff"><span =
style=3D'color:
#3366FF'>System.Text.Encoding.GetEncoding(&quot;latin1&quot;) =
</span></font>I
get the same error of:&nbsp; <br>
Unhandled Exception: System.NotSupportedException: Encoding name =
`latin1' not
supported<br>
in [0x000fe] (at
/opt/src2/mono-all/1.0.4/mcs-1.0.4/class/corlib/System.Text/Encoding.cs:4=
46)
System.Text.Encoding:GetEncoding (string)<br>
<br>
Now I figure this is a problem either with System.Text or with the =
Mysql.Data
Library.&nbsp; But I can not tell unless I can find documentation of =
whether or
not System.Text should support the string value of =
&quot;latin1&quot;.<br>
<br>
Does anyone know where the requirments for System.Text are kept?&nbsp; =
<br>
<br>
In addition, apparently I will not be able to get this library to work =
with my
MySql database unless I change the language encoding.&nbsp; Does anyone =
have
any experience on which charchter set is common to both DotNet and =
MySql?<br>
<br>
Finally, does anyone know to Whom do I contact to see if I can be of any =
help
in the area of documentation?<br>
<br>
Regards,<br>
<br>
Joshua<br>
<br style=3D'mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br =
style=3D'mso-special-character:line-break'>
<![endif]><o:p></o:p></p>

</div>

</div>

</body>

</html>

------=_NextPart_000_0176_01C4CC7B.B573B7C0--