I have a program which takes a value from an Access database and makes a text file.
The file is used to update a MySql database. I have some German characters, so I encoded the file using the following code:
My.Computer.FileSystem.WriteAllText("MyFile", t.ToString, False, System.Text.Encoding.Default)
It works fine, that is until it encounters a character outside the ASCII set, such as the ™ (Trade Mark) symbol. All I get when viewed in Textpad is a | style character indicating that it cannot be viewed. It's the same story when I view the database.
Is this an issue with VB.NET or the way in which I am encoding the file?
The file is used to update a MySql database. I have some German characters, so I encoded the file using the following code:
My.Computer.FileSystem.WriteAllText("MyFile", t.ToString, False, System.Text.Encoding.Default)
It works fine, that is until it encounters a character outside the ASCII set, such as the ™ (Trade Mark) symbol. All I get when viewed in Textpad is a | style character indicating that it cannot be viewed. It's the same story when I view the database.
Is this an issue with VB.NET or the way in which I am encoding the file?
