Click here to Skip to main content
15,919,245 members
Home / Discussions / C#
   

C#

 
AnswerRe: Quick Question - Data Validation Range with DateTime Pin
Eddy Vluggen16-Jul-19 23:22
professionalEddy Vluggen16-Jul-19 23:22 
GeneralRe: Quick Question - Data Validation Range with DateTime Pin
BillWoodruff17-Jul-19 0:43
professionalBillWoodruff17-Jul-19 0:43 
GeneralRe: Quick Question - Data Validation Range with DateTime Pin
Eddy Vluggen17-Jul-19 1:09
professionalEddy Vluggen17-Jul-19 1:09 
GeneralRe: Quick Question - Data Validation Range with DateTime Pin
OriginalGriff17-Jul-19 2:49
mveOriginalGriff17-Jul-19 2:49 
GeneralRe: Quick Question - Data Validation Range with DateTime Pin
Eddy Vluggen17-Jul-19 13:53
professionalEddy Vluggen17-Jul-19 13:53 
AnswerRe: Quick Question - Data Validation Range with DateTime Pin
Gerry Schmitz17-Jul-19 6:15
mveGerry Schmitz17-Jul-19 6:15 
Questionhow I input Hebrew from winForm to mySql Pin
Member 1387299916-Jul-19 0:17
Member 1387299916-Jul-19 0:17 
AnswerRe: how I input Hebrew from winForm to mySql Pin
OriginalGriff16-Jul-19 0:36
mveOriginalGriff16-Jul-19 0:36 
That's probably more to do with how you are retrieving and displaying it than anything else: "Hebrew" is a part of a characters set, and not all sets will contain the appropriate glyphs for it to display correctly. When it doesn't, one of the displays you get is '?' to indicate it.
The big possibility is that you are storing them in a non-UNICODE column in your DB: If it's NVARCHAR it's OK, if it's VARCHAR then it won't work correctly.

So start by doing "test inserts": use your existing code to insert a "known good" Hebrew phrase string to SQL, and simultaneously convert it to a byte array:
C#
byte[] bytes = System.Text.Encoding.UTF8.GetBytes(myHebrewString);

Then retrieve the same string from the DB (using your existing code) and convert that to a byte array as well.
Compare the strings, and compare the byte arrays. If they are the same then the DB and the store / restore code is fine, so you need to start looking at your display code.

Sorry, but we can't do any of that for you!
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

GeneralRe: how I input Hebrew from winForm to mySql Pin
Member 1387299916-Jul-19 0:54
Member 1387299916-Jul-19 0:54 
GeneralRe: how I input Hebrew from winForm to mySql Pin
Luc Pattyn16-Jul-19 3:31
sitebuilderLuc Pattyn16-Jul-19 3:31 
GeneralRe: how I input Hebrew from winForm to mySql Pin
Member 1387299916-Jul-19 7:08
Member 1387299916-Jul-19 7:08 
Questionregular expression to extract data from a html table with TD marked with id using C# Pin
Indexon India15-Jul-19 6:06
Indexon India15-Jul-19 6:06 
AnswerRe: regular expression to extract data from a html table with TD marked with id using C# Pin
OriginalGriff15-Jul-19 6:14
mveOriginalGriff15-Jul-19 6:14 
JokeRe: regular expression to extract data from a html table with TD marked with id using C# Pin
Richard Deeming15-Jul-19 7:52
mveRichard Deeming15-Jul-19 7:52 
GeneralRe: regular expression to extract data from a html table with TD marked with id using C# Pin
OriginalGriff15-Jul-19 8:04
mveOriginalGriff15-Jul-19 8:04 
AnswerRe: regular expression to extract data from a html table with TD marked with id using C# Pin
#realJSOP15-Jul-19 23:39
professional#realJSOP15-Jul-19 23:39 
QuestionC# error: “An object reference is required for the non-static field, method, or property” Pin
wrightyrx714-Jul-19 23:24
wrightyrx714-Jul-19 23:24 
AnswerRe: C# error: “An object reference is required for the non-static field, method, or property” Pin
OriginalGriff14-Jul-19 23:35
mveOriginalGriff14-Jul-19 23:35 
GeneralRe: C# error: “An object reference is required for the non-static field, method, or property” Pin
wrightyrx714-Jul-19 23:50
wrightyrx714-Jul-19 23:50 
GeneralRe: C# error: “An object reference is required for the non-static field, method, or property” Pin
OriginalGriff15-Jul-19 0:17
mveOriginalGriff15-Jul-19 0:17 
GeneralRe: C# error: “An object reference is required for the non-static field, method, or property” Pin
wrightyrx715-Jul-19 0:33
wrightyrx715-Jul-19 0:33 
GeneralRe: C# error: “An object reference is required for the non-static field, method, or property” Pin
OriginalGriff15-Jul-19 0:47
mveOriginalGriff15-Jul-19 0:47 
GeneralRe: C# error: “An object reference is required for the non-static field, method, or property” Pin
wrightyrx715-Jul-19 3:08
wrightyrx715-Jul-19 3:08 
GeneralRe: C# error: “An object reference is required for the non-static field, method, or property” Pin
OriginalGriff15-Jul-19 3:46
mveOriginalGriff15-Jul-19 3:46 
AnswerRe: C# error: “An object reference is required for the non-static field, method, or property” Pin
phil.o14-Jul-19 23:52
professionalphil.o14-Jul-19 23:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.