Solved

Save special characters in MYQSL using VB.net

Posted on 2013-01-13
6
321 Views
Last Modified: 2013-04-24
I am tryin to save a ¿  into a mysql database field. How can I do this so that I can later retrive it.
0
Comment
Question by:whiwex
  • 5
6 Comments
 

Author Comment

by:whiwex
ID: 38773098
Sorry the character I am trying to save is a music note. The text in Expert Exchange changed the music note to a upsidedown ?  I am trying to save a music note to the database
0
 

Expert Comment

by:chughes54
ID: 38773129
I'm not sure which music note you are trying to store...
Just store whichever one you want in this format:

♩


Here is a list of them
http://www.alt-codes.net/music_note_alt_codes.php

Hope that helps!
0
 

Author Comment

by:whiwex
ID: 38773211
What I am doing is the user entered a ¿ by going to Start/Accessories/Character Map copying and then pasting into a text box. Then when they click a save button the text box is saved into a MYSQL database BLOB field. Then the user can click a print button and the MYSQL field is printed as a crystsal report. Everyting works fine except the music notes are not printed they show up as a box where the ¿ should be.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:whiwex
ID: 38773213
In the above post the upside down ? was suppose to be a music note.
0
 

Accepted Solution

by:
whiwex earned 0 total points
ID: 39094148
Please close never resolved
0
 

Author Closing Comment

by:whiwex
ID: 39107613
Please close it was never resolved
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question