Esempio n. 1
0
        public TSQLStringLiteral(
            int beginPostion,
            string text) :
            base(
                beginPostion,
                text)
        {
            // need to find unescaped value insides quote characters

            // there are three different possible quote characters that we might support for string literals

            // if this is a unicode string it will begin with N
            int quotePosition = 0;
            int length        = text.Length - 2;

            if (text[0] == 'N')
            {
                quotePosition++;
                length--;
                IsUnicode = true;
            }
            else
            {
                IsUnicode = false;
            }

            // now we can find which quote character we're using
            QuoteCharacter = text[quotePosition];

            // now unescape doubled up quote characters
            Value = text.Substring(quotePosition + 1, length)
                    .Replace(new string(QuoteCharacter, 2), QuoteCharacter.ToString());
        }
        /// <summary>
        /// Retrieves a token from a character array.
        /// </summary>
        /// <param name="chars">the character array containing the token</param>
        /// <param name="start">the index of the first character of the token</param>
        /// <param name="end">the index of the last character of the token</param>
        /// <returns>the token without the surrounding quotes, or the token itself if there are no surrounding quotes</returns>
        private string RetrieveToken(char[] chars, int start, int end)
        {
            var startQuote = start;
            var endQuote   = end;

            // Remove quotes if necessary
            if (SearchQuote(chars, ref startQuote, ref endQuote))
            {
                var token = new string(chars, startQuote + 1, endQuote - startQuote - 1);
                token = token.Replace(QuoteCharacter.ToString() + QuoteCharacter, QuoteCharacter.ToString());
                return(token);
            }
            return(new string(chars, start, end - start + 1));
        }
Esempio n. 3
0
        internal TSQLStringLiteral(
            int beginPosition,
            string text) :
            base(
                beginPosition,
                text)
        {
            // need to find unescaped value insides quote characters

            // there are three different possible quote characters that we might support for string literals

            // if this is a unicode string it will begin with N
            int quotePosition = 0;
            int length        = text.Length - 2;

            if (text[0] == 'N')
            {
                quotePosition++;
                length--;
                IsUnicode = true;
            }
            else
            {
                IsUnicode = false;
            }

            // now we can find which quote character we're using
            QuoteCharacter = text[quotePosition];

            // trim off the leading and trailing quotes
            Value = text.Substring(quotePosition + 1, length);

            // now unescape doubled up quote characters
            Value = Value.Replace(new string(QuoteCharacter, 2), QuoteCharacter.ToString());

            // remove line continuation backslash
            // https://docs.microsoft.com/en-us/sql/t-sql/language-elements/sql-server-utilities-statements-backslash?view=sql-server-2017
            Value = Value.Replace("\\\r\n", "");
            Value = Value.Replace("\\\n", "");
        }