mysql - SQL query for ASCII Charcters -


i writing query replace ascii charcters. before need search text contains ascii character.

 select * __item description '%Â%';

how query find descrption under __item table contains character  ??

try: 

select * __item description '%Â%' collate utf8_general_ci;

Comments

Post a Comment

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

Image
recently have uploaded wordpress site onto server. have uploaded wordpress site in sub-folder under root folder ../root(domain root folder)/wordpress (where host wordpress folder). now problem content data in page or post in dashboard of wordpress admin panel not showing - see image. but data showing in front view - see image. if not browser cache issue , not issue happened tinymce editor during upgrade; try add config file: define('concatenate_scripts', false);
Read more

c# - Abstract method in public abstract class implementing an internal interface doesn't compile? -

internal interface i_foo { void bar(); } public abstract class a_foo : i_foo { public a_foo() { } abstract void i_foo.bar(); } public class foo : a_foo { public foo() : base() { } internal override void bar() { } } hello! i'm trying have methods visible outside code, , other visible assembly. purpose, made internal interface i_foo serve contract other parts of assembly, public abstract a_foo serve abstraction external code, , centralize constructor functionality, , several different classes foo implement a_foo , i_foo explicitly retain internal modifier. however, in a_foo class, get 'a_foo.i_foo.bar()' must declare body because not marked abstract, extern, or partial even though method marked "abstract". if add body, "abstract not valid modifier". i need method explicitly declared, in order internal in public class, , need abstract can override in actual implementation foo. why doesn't compiler let m...
Read more

authentication - Mongodb revoke acccess to connect test database -

i have ec2 instance mongodb 3.2.0 installed. have user admin access. can connect user , perform operation remotely. 1 can connect database test remote if knows ip mongo 11.11.11.11. although not able make operations, want restrict access user credentials can connect server. first need create users , grant roles users, example: use admin db.createuser( { user: "myuseradmin", pwd: "abc123", roles: [ { role: "useradminanydatabase", db: "admin" } ] } ) then need start server --auth parameter mongod --auth more information here
Read more