maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

Hi Peter!


2014-03-19 18:03 GMT-03:00 Peter Laursen <peter_laursen@xxxxxxxxxx>:

> Obivously this is the best solution
> SELECT LENGTH("banana") - LENGTH( REPLACE("banana","n",""));
> (so no need or a Stored Function)
>
> .. however you may consider to replace LENGTH with CHAR_LENGTH, This is
> important if you use UTF8 and if you have non-ASCII characters (what you
> undoubtedly have as a Brazilian person (I guess you are?)). This example
> with the Spanish "ñ" character illustrates:
>

Yes =D Brazil heeh, sorry my english, i change some words and wrote
sometimes as i think in portuguese (are you going? => you are going? kk
portuguese have a different grammar)

No problem :) i'm using latin1 here at columns and server and client


>
> SET NAMES utf8;
> SELECT LENGTH("bañaña") - LENGTH( REPLACE("bañaña","ñ",""));
> -- returns "4" (4 *bytes* more exactly) - and this result is not what your
> are after!
>
> -- whereas
> SET NAMES utf8;
> SELECT CHAR_LENGTH("bañaña") - CHAR_LENGTH( REPLACE("bañaña","ñ",""));
> -- returns "2" (2 *characters* more exactly) - and this is what you want.
>

yeap :) i know how to use charsets, char_length is the right function with
multibyte text, but no problem :)

i considred a nice idea form adam
instead of remove the character, add a new character
length(replace('banana','n','n+'))-length('banana')

if i replace 'asdfasdf' with 'asdfasdf+', i have only one new character :)
that's nice


>
>
> -- Peter
>
thanks!


>
>
> On Wed, Mar 19, 2014 at 6:16 PM, Federico Razzoli <federico_raz@xxxxxxxx>wrote:
>
>> When a PHP function does something you cannot do in SQL, you could call
>> PHP from your queries using the Gearman UDF.
>>
>> https://launchpad.net/gearman-mysql-udf
>>
>> In most cases this should be faster than a stored function. I hope that
>> in the future this will change, but who knows...
>>
>> Regards,
>> Federico
>>
>>
>> --------------------------------------------
>> Mer 19/3/14, Roberto Spadim <roberto@xxxxxxxxxxxxx> ha scritto:
>>
>>  Oggetto: Re: [Maria-discuss] help - i'm not finding one sql function
>>  A: "pslawek83" <pslawek83@xxxxx>
>>  Cc: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
>>  Data: Mercoledì 19 marzo 2014, 16:18
>>
>>  wow!
>>  thanks kk i was trying to find a php like functionyour
>>  idea is very nice :) thank you!
>>  substr_count =>
>>  (length(field)-length(replace('
>>  ','',field)))
>>
>>  /)
>>
>>  2014-03-19 12:16 GMT-03:00
>>  pslawek83 <pslawek83@xxxxx>:
>>
>>  Hi
>>  Roberto,
>>  You'll have to replace char
>>  => empty and get the difference in length.
>>
>>  SELECT
>>  (length("banana") - replace("n",
>>  "", "banana"))
>>
>>
>>  There's probably no
>>  "standard" function to do that.
>>
>>
>>  Dnia 19 marca
>>  2014 15:51 Roberto Spadim <roberto@xxxxxxxxxxxxx>
>>  napisał(a):
>>
>>
>>
>>
>>
>>
>>  hi guys, i'm not finding a function to
>>  return how many character i have, for example:
>>
>>  "banana"
>>
>>  i want a function that return 2 "n"
>>  characters, example:
>>  substr_count("banana","n") =>
>>  2
>>
>>  sorry it a begginners question, but i didn't found
>>  it in mysql/mariadb manual
>>
>>
>>  --
>>
>>  Roberto Spadim
>>  SPAEmpresarial
>>  Eng. Automação e Controle
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>  --
>>  Roberto Spadim
>>  SPAEmpresarialEng. Automação e
>>  Controle
>>
>>  -----Segue allegato-----
>>
>>  _______________________________________________
>>  Mailing list: https://launchpad.net/~maria-discuss
>>  Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>>  Unsubscribe : https://launchpad.net/~maria-discuss
>>  More help   : https://help.launchpad.net/ListHelp
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle