sql - VB.net regex character syntax -


i can't sql query using regex work in vb.net.

if write 

dim localconnection new mysqlconnection = connectionnew(dbname) dim da mysqldataadapter dim ds new dataset dim rows long  sqlstatement= "select `col1` `mytable` `col1` regexp '^[a-z]bc$'"   da = new mysqldataadapter(sqlstatement, localconnection)  rows = da.fill(ds)

it returns null, though there cell containing "abc". when run directly on database, returns row correctly.

if remove [a-z], works fine in both circumstances.

is possible "binary strings" involved?

from: http://dev.mysql.com/doc/refman/5.1/en/regexp.html

regexp not case sensitive, except when used binary strings.

it makes warnings multi-byte characters.

the regexp , rlike operators work in byte-wise fashion, not multi-byte safe , may produce unexpected results multi-byte character sets. in addition, these operators compare characters byte values , accented characters may not compare equal if given collation treats them equal.

since vb.net works in unicode, possible sort of character-set or code-page mangling may happening behind scenes?


Comments

Post a Comment

Popular posts from this blog

WPF: binding viewmodel property of type DateTime to Calendar inside ItemsControl -

Image
i have problem wpf binding. want bind list of months itemscontrol shows calendar control each month. each rendered calendar shows datetime.now,not bound datetimes. know why happening? this have far: the mainwindow.xaml <window x:class="calendarlisttest.mainwindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" title="mainwindow" height="350" width="525"> <grid> <itemscontrol x:name="calendarlist"> <itemscontrol.itemtemplate> <datatemplate> <calendar displaydate="{binding currentdate}" /> </datatemplate> </itemscontrol.itemtemplate> </itemscontrol> </grid> ** place collection assigned itemssource** private void window_loaded( object sender, routedeventargs e ) { cale...
Read more

java - Getting corefrences with Standard corenlp package -

i'm trying coreferences in text. i'm new corenlp package. tried code below, doesn't work, i'm open other methods well. /* * change template, choose tools | templates * , open template in editor. */ package corenlp; import edu.stanford.nlp.ling.coreannotations.collapsedccprocesseddependenciesannotation; import edu.stanford.nlp.ling.coreannotations.corefgraphannotation; import edu.stanford.nlp.ling.coreannotations.namedentitytagannotation; import edu.stanford.nlp.ling.coreannotations.partofspeechannotation; import edu.stanford.nlp.ling.coreannotations.sentencesannotation; import edu.stanford.nlp.ling.coreannotations.textannotation; import edu.stanford.nlp.ling.coreannotations.tokensannotation; import edu.stanford.nlp.ling.coreannotations.treeannotation; import edu.stanford.nlp.ling.corelabel; import edu.stanford.nlp.pipeline.*; import edu.stanford.nlp.trees.tree; import edu.stanford.nlp.trees.semgraph.semanticgraph; import edu.stanford.nlp.util.coremap; import e...
Read more

Java - Returning an array from a method to main -

would glad if can me following problem. following method suppose returns array ith entry number of times int appeared in array a. method name gives use of method. drawing histogram of data found in array a. public static int histogram(int m, int[] a){ int[] b = new int[m]; (int = 0; < m; i++){ int w = 0; (int j = 0; j < a.length; j++){ if (a[j] == i){ w++; } } b[i] = w; } return b; } accoring me code correct - may wrong - can't test because i've got error thats bugging me. histogram.java:22: incompatible types found : int[] required: int return b; 1) above mean?? on example on internet , in handbook use "return b;" return array main program. 2) how return function work? able use following code print values of array b? because @ moment error array b not being initialised in main... think error go away if error 1 sorted out...
Read more