| |
| UTF-8 textfile importing in VB.NET doesn't work
|
|
|
Location: Blogs Ferry Onderwater - Developer |
 |
| Posted by: Ferry Onderwater |
2-2-2009 16:51 |
When trying to import a textfile which is encoded with UTF-8 I can't get it right. I do use a schema.ini and OLEDB but the schema.ini is ignored.
The case: I have a textfile, UTF-8 encoded. I need to import this textfile with VB.NET into a datatable. To do this I use a schem.ini file:
[UTF8.txt]
format=Delimited(;)
colnameheader=true
maxscanrows=0
CharacterSet=65001
The characterset should make it work but instead of a nice Fërry I see something like Férry.
The whole trick was too simple to keep it to myself. By default, my code wrote the schema.ini in..... UTF-8... So adding an encoding-type to the write statement was all I needed to do :)
My.Computer.FileSystem.WriteAllText(SchemaFile, SchemaTemplate, False, System.Text.ASCIIEncoding.ASCII)
|
| Copyright ©2009 Ferry Onderwater |
| Permalink |
Trackback |
Comments (38)
Add Comment
|
Coach Handbags |
By Coach Handbags on
16-7-2010 7:33 |
utopia
With Coach Handbags of styles and colors to choose from you really can’t go wrong.The heels collection provides everything from the big hit of the season ankle boots, to strappy Nike Air Jordan.After hitting the market in 2004, Tory Burch Cheap Gucci Shoes have become a fashion essential for those looking for the latest in style and surprisingly comfort. Michael Jordan Shoescome in a wide range of variety and styles. The big portion of their market and nike dunk appeal comes from their collection of flats that not only is trendy but is known for their wear ability and comfort.With a wide range of designers and Nike Air Jordan on the market, these fashionista savvy Cheap MBT Shoes can come off the cover of Elle magazine without breaking the bank. |
|
|
|
|
nothing is impossible··· |
By anlia on
26-7-2010 3:00 |
Thanks for your sharing, good job!
If you are the fans of gucci outlet series, the topguccishoes.com website will be the best and right place that you have come to. A full collection of gucci sneakers products are proud of supplying for you, such as Gucci clothing, gucci jeans, ugg bailey button boots, Gucci skirt, Gucci bikini, Gucci spicy underwear, UGG Classic Tall|UGG Classic Short as well as you can find the discount gucci shoes, stylish Gucci shoes for women with high and low performance, discount gucci handbags for male and female, gucci hats for sale, bailey button ugg boots|ugg boots bailey button, gucci accessories and so on. In a word, the Gucci products ugg classic |ugg kids online can well meet the different requirement from numerous people. |
|
|
cheap ugg boot store |
By ugg australia on
29-7-2010 4:40 |
| Not even as I shook womens ugg boots and trembled uncontrollably in the trenches, did I forget your ugg boots face. I would sit huddled into the wet mud, terrified, as the ugg australia hails of bullets and mortars crashed down around me. I would clutch my uggs bailey button rifle tightly to my heart, and think again of that very first day we met. I would cry out in bailey button boots fear, as the noise of war beat down around me. But, as I thought ugg boots in uk of you and saw you smiling back at me, everything ugg boots usa around me would be become silent, and I would be with you again for a few precious official ugg boots moments, far from the death and destruction. It would not be ugg classic cardy until I opened my eyes once again, that I would see and hear the carnage of the war around me.I cannot tell you ugg classic cardy boots how strong my love for you was back then, when I returned to you on leave in the September, feeling uggs classic cardy battered, bruised and fragile. We held each other so tight I thought ugg uk we would burst. |
|
|
shi |
By fiwedding on
30-7-2010 3:55 |
supply in stock and custom lace front wigs, full lace wigs, lace wigs, human hair wigs,
remy lace front wigs, cheap wigs, cheap, buy, celebrity
full lace wigs
lace wigs
lace wigs sale
lace front wigs
synthetic front lace wigs
A Famous Dresses Shop which sell directly Wedding Dresses, Evening Dress, Bridesmaid Dresses,Prom dresses
cheap wedding dresses
cheap evening dresses
cheap prom dresses
cheap evening dresses
cheap prom dresses
Elegant evening dresses are always associated with the brides and their bridesmaids.Shopping for evening dresses and your wedding dress in stylish bridal ..
|
|
|
|
mens timberland boots |
By timberland 6 inch on
1-8-2010 14:16 |
| One Sunday womens timberland boots morning, I was told that someone was waiting for me in timberland 6 boots office. The young person who answered the rectory timberland boots door said that it was "the woman who said she left all the notes." When I saw her mens timberland boots I was shocked, since I immediately recognized her from church but had no timberland boots outlet idea that it was she who wrote the notes. She was sitting in a chair in timberland roll top boots office with her hands folded in her lap. Her head was bowed and when she raised white timberland boots it to look at me, she could barely smile without pain. Her face was disfigured, and timberland classic boat skin so tight from surgical procedures that smiling or laughing was very difficult for her timberland kids waterproof boots . She had suffered terribly from treatment to remove the growths timberland shoes that had so marred her face. We chatted for a while that Sunday morning and agreed to meet for timberland womens premium boots lunch later that week. As it turned out we went to lunch several timberland boots women times, and she always wore a hat during the meal. I think that treatments of some timberland shoe company sort had caused a lot of her hair to fall out. We shared things about our lives. I told her about my women timberland shoes schooling and growing up. She told me that she had worked for timberland 6 inch years for an insurance company. She never mentioned family, and I did not ask. I have thought about her timberland mens custom often over the years and how she struggled in a society that places an incredible premium on looks, class, wealth and all the other fineries of life. She suffered from a disfigurement that cannot be made to look attractive. I know that her condition black timberland boots hurt her deeply. |
|
|
Betr: UTF-8 textfile importing in VB.NET doesn't work |
By cheap prom dresses on
4-8-2010 7:45 |
| Check out what the stars wear to the Oscars, prom dresses,cheap prom dresses,wedding invitations,medium hairstyles Golden Globes and other awards. If your wife is older, don't go for a Lady Gaga outfit. Think elegance. Meryl Streep, Susan Sarandon are two actresses to look for. They tend to wear outfits to awards that look beautiful and stunning. This is just to gather ideas, not dish out designer prices (unless of course you have that in your budget). |
|
|
Betr: UTF-8 textfile importing in VB.NET doesn't work |
By cheap prom dresses on
4-8-2010 7:47 |
| Check out what the stars wear to the Oscars, prom dresses,cheap prom dresses,wedding invitations,medium hairstyles Golden Globes and other awards. If your wife is older, don't go for a Lady Gaga outfit. Think elegance. Meryl Streep, Susan Sarandon are two actresses to look for. They tend to wear outfits to awards that look beautiful and stunning. This is just to gather ideas, not dish out designer prices (unless of course you have that in your budget). |
|
|
Betr: UTF-8 textfile importing in VB.NET doesn't work |
By full lace wigs on
4-8-2010 7:50 |
| Check out what the stars wear to the Oscars, lace wigs,full lace wigs,lace front wigs Golden Globes and other awards. If your wife is older, don't go for a Lady Gaga outfit. Think elegance. Meryl Streep, Susan Sarandon are two actresses to look for. They tend to wear outfits to awards that look beautiful and stunning. This is just to gather ideas, not dish out designer prices (unless of course you have that in your budget). |
|
|
Betr: UTF-8 textfile importing in VB.NET doesn't work |
By dgfg on
14-8-2010 4:20 |
Wholesale Free shippinglouis vuitton handbagsRolex watches of Louis
collection and the way to louis vuitton trim paves trim paves |
|
|
|
If you want tougg classic tall boot pewter equivalent ugg classic tall sunflowera undefeated web
By ugg boots outlet on
19-8-2010 7:46 |
| If you want tougg classic tall boot pewter equivalent ugg classic tall sunflowera undefeated web ugg classic tall chestnut,designer, you exigency go into,usable, functionalugg classic tall black,,interface designs at the ugg classic tall chocolate,crux of your work. , ugg classic tall bomber boot This will contribute ,to the fleshingugg classic tall grey , out of ,not humle , ,ugg classic tall navy, your convoy ugg classic short sand, (or whatever vigor you design for),ugg classic short chestnut,,but moreoverugg classic short ultramarine,mini ugg boots, ugg classic short spiced coral ,besides,ugg classic short chocolate, furthermore,ugg classic short sale, further yourself.ugg classic short fancy,A popularugg classic short metallic, interconfront designugg classic cardy boots grey,is crucialugg classic cardy grey ,you can takeugg classic cardy black,pride in ugg classic cardy oatmeal,and leave getugg classic cardy boots black,you futureugg classic cardy fig,contracts.ugg classic cardy tall ,Clickable ugg classic cardy sale,Wireframes, ugg bailey button triplet,Usability ugg bailey boots, Testing andugg bailey button bomber,Digital Paper ugg bailey button side boots,Prototyping.ugg bailey button uk, Fast wireframeugg bailey button bomber boots,creation andugg bailey button grey,remote website ugg bailey button sale,usability testing lead to anugg bailey button boots,larger conversion! . |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
jordan shoes |
By jordan on
2-9-2010 13:35 |
|
|
|
2.html'>Supra Skylow Light Grey, Supra Skylow Light Grey |
By 2.html'>Supra Skylow Light Grey
3-9-2010 10:23 |
|
|
|
|
|
Yves Saint Laurent Shoes |
By Yves Saint Laurent on
4-9-2010 3:36 |
Yves Saint Laurent is a legendary designer in the fashion industry. He has credit of designing some of the best handbags, shoes, purses, satchels and totes for women. Saint Laurent has created four major designer lines, which are hugely popular and can be seen on celebrities and other rich women every day. Over the past years, YSL is known for premier quality and distinctstyle.Originally, YSL shoes, especially the Yves Saint Laurent Sandals are designed for working professionals to provide comfort, dependability and protection on the job. In spite of heavy-duty requirements, such footwear is lightweight and trendy. Yves Saint Laurent Pumpssexy and very practical.You can wear them for work and leisure. Wear them at the beginning of the workday at the office, and later, in discos. As the improvement of our living standard, the shoe market is already flooded with numerous manufacturers, YSL obviously faces stiff competition, but in the midst of this inevitable condition, its footwear is seen protecting feet of individuals irrespective of age and sex. The YSL Sandals offer you with maximum comfort as you go through your outdoor activities, including shopping; visiting friends, camping, nature tripping and the list goes on. In addition, YSL Sandals endure all kinds of weather conditions without failing. And so doesYves Saint Laurent Boots, which are also great choice for ladies.
Tamara Mellon for this brand by a master hand with East London shoemakerjimmy choo was founded in 1996. Tamara aware of the practical fashion footwear market needs, is therefore logical to introduce this stylish footwear product line. Jimmy Choo shop Knightsbridge in London first opened its first stores that, with fun and full of beautiful and "sexy just right" design, soon to become well recognized creative footwear. In 1998, jimmy choo shoes was opened its first New York branch, then in 1999 opened its second store in Los Angeles. Brand fame, popular young Hollywood family, a red carpet on the best choice, and even jumped for the Oscar winner Halle Berry and Hilary Swank so lucky star mark. These jimmy choo handbags, jimmy choo pumps, jimmy choo sandals, jimmy choo boots have really revolutionized footwear that you should be glad to add to your collection – chick, cool and functional. You could not ask for more and it’s well worth the money you spent on them.
gucci shoes are several of the finest fashionable shoes that you can see in the market today. Being a leader in fashion, Gucci's products constantly highlight the latest, most fashionable styles of shoes. These shoes are made out of top quality materials and created delicately and elaborately to guarantee the best quality. Cheap Gucci Shoes is well-recognized for its elegant and luxurious pairs of shoes and to the upper class owning pairs of discount gucci shoes is certainly a sign of fame and wealth. Most individuals are so familiar with Gucci brands because it is recognized for its high end products all across the world. What women want are designer women's shoes. Women love shoes. Some women are obsessed with shoes. Many ladies, young and old, have dozens of pairs of shoes. There are women that own enough pairs of shoes to wear a different pair, every day. gucci women shoesis one of the best shoes. Do take out some time and shop around so that you are able to save bit of money on your favorite pair of shoes. gucci men shoes are undoubtedly among the finest of the designer mens Shoes available in the market today. Being the leaders in the arena of high fashion, Gucci's range at all times features some of the latest and most classy shoes. Now, many cheap gucci shoes are on sale.
|
|
|
replica watches |
By lfclhy13709394 on
6-9-2010 9:10 |
Even adolescents nowadays have started to pay attention to watches. You don?t have to be grown-up to notice replica breitling aerospace watches the elegance of some timepieces and the tremendous influence they can have to the beauty of an outfit breitling aerospace replica watches and to your personality.Rolex replicas, replica cartier 21 must de cartier watches the affordable series of timepieces of the average man and woman, can really make you feel good, if you are one of those who adore replica cartier watches the Rolex line but cannot afford the real thing. A high-class fake Rolex watch like the Swiss Rolex replica is a
|
|
|
|
|
|
|
|
|
|
|