c# - Can mysql fields in greek language be displayed in crystal reports? -


creating mysql table fields in greek language not smart. newbie found out. fields cannot displayed in crystal reports (cr visual studio version 13.08). have thousands lines of code take me ages changing mysql fields , change queries. using c# through visual studio 2012.

i checked many solutions have found online changing font, changing regional settings of pc or changing collation of database , nothing has worked.

those fields displayed question marks ?? , when try run program error message: mysql(42s22) unknown column in 'field list' error 1054

any appreciated, thank

i had problem , tried above mentioned, , solution found was:

  1. go odbc data source adminstrator (access 'set odbc data sources' )
  2. on user data source choose database , press configure,
  3. and go down details , press it,
  4. now see 'character set' field, press , choose 'greek'
  5. save,exit , go visual studio project, , create new crystal report
  6. then choose make new connection(i did again sure configuration of database changed)
  7. i used new database display tables, , must not question marks!!! hooray!
  8. use font supports greek characters, used hellasarial, , greek displayed on report.

Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

inno setup - TLabel or TNewStaticText - change .Font.Style on Focus like Cursor changes with .Cursor -

is possible change .font.style on focus tlabel or tnewstatictext happens cursor when use .cursor ? there no built-in support track mouse hovering in inno setup @ time. however, intercepting window procedure of controls can track yourself. following example need innocallback library: [setup] appname=my program appversion=1.5 defaultdirname={pf}\my program outputdir=userdocs:inno setup examples output [files] source: "innocallback.dll"; destdir: "{tmp}"; flags: dontcopy [code] #ifdef unicode #define aw "w" #else #define aw "a" #endif const gwl_wndproc = -4; wm_mousemove = $0200; type wparam = uint_ptr; lparam = longint; lresult = longint; twindowproc = function(hwnd: hwnd; umsg: uint; wparam: wparam; lparam: lparam): lresult; function setcapture(hwnd: hwnd): hwnd; external 'setcapture@user32.dll stdcall'; function releasecapture: bool; external 'releasecapture@user32.dll stdcall'; func...
Read more