Strange pl/sql behavior – last character is removed in the Select statement, but actual data has different length

We have a table with a column name A with type nvarchar(23).

following query will always return 23 which means that the actual length of all records are 23.

select length(trim(req.A)), count(*)   from tableName req group by length(trim(req.A)); 
 |length(trim(req.A))|count(*)|  ------------------------------ |23                 |1006    | 

But when we select from this table with this query it behaves different and it seems that the last character is always removed in result Gridview in the pl/sql developer.

select LENGTHB(req.A) lenb, length(req.A) len, req.* from tableName req where req.A = 'NHBBBBB1398052635902235'; -- Note to the equal sign and the last charactar (5) of the where clause 

the result is:

 |lenb|len|          A           | --------------------------------- |46  |23 |NHBBBBB139805263590223| 

As you can see the last character (5) is removed in the select result.

Can you please explain whats happen!? Is this related to pl/sql configs? How to solve this?

How can I add a new character to an existing keyboard?

I currently have the Greek (Polytonic) keyboard layout installed, and it works wonderfully for typing Ancient Greek.

However, I sometimes find myself needing to type the obscure letter digamma (capital Ϝ, lowercase ϝ), which isn’t available on this keyboard. Ideally I’d move the final sigma to the Q key, and put digamma on the W.

Is there an easy way to accomplish this? I found this page, but it warns me that it’s not updated for current versions of Ubuntu. Moreover, digamma is too obscure to be given a name in /usr/include/X11/keysymdef.h (though it does have suitable codepoints in Unicode), and I’m not sure what I’d have to recompile if I edited that file.

Can a character of average intelligence be bilingual by default in Pathfinder 2e?

My friend recently started rebuilding his 1e half-orc monk character in Pathfinder 2e. For context, this is a man who grew up in an orc camp and then lived in a (presumably mostly human) monastery for a while.

Now, according to the new 2e rules, half-orcs begin the game by speaking Common (as opposed to Common and Orcish like in 1e) with the option of knowing more languages if their INT score is high enough (or by putting points into Linguistics, possibly?). While I agree that a character shouldn’t automatically know a language just by virtue of their ancestry (a half-orc raised by a single non-orc parent likely wouldn’t speak Orcish unless they explicitly studied the language), I nevertheless think that in this particular case it is absolutely justified for the character to know two languages – without taking a voluntary flaw in Wisdom or Charisma to increase Intelligence from 11 to 12, because that’s just how bilingualism works.

Am I right in insisting he should get his second language “for free”, bearing in mind this would mostly just be for flavour anyway (we have another half-orc character in the party) or am I being unreasonable in trying to apply real-world rules to game phenomena?

Edit for clarification: We’re taking turns DMing, so there’s no single person to have the last word. The question is more about whether it is theoretically possible to justify the above based on the rules, as opposed to it being a DM concession.

How many charges does a multiclass character imbue a staff with?

This is a Pathfinder Second Edition question.

Let’s say that we have a fourth-level cleric who has taken Wizard Dedication and Basic Wizard Spellcasting (both CRB pg. 231) at second and fourth levels respectively. This character has second-level spell slots they can use for divine spells because they are a cleric and one first-level spell slot they can use for an arcane spell from Basic Wizard Spellcasting.

They acquire a Staff of Fire (CRB pg. 594), which can be used to cast burning hands. Burning hands is on their spell list because they have access to arcane spells from Wizard Dedication, and so they can Cast that Spell from the staff. The specific rule governing this is on CRB pg. 592:

You can Cast a Spell from a staff only if you have that spell on your spell list, are able to cast spells of the appropriate level, and expend a number of charges from the staff equal to the spell’s level.

Because they can Cast some Spell from it, they can prepare the staff when they perform their daily preparations and imbue it with some charges. Here’s the relevant rule from the same page:

During your daily preparations, you can prepare a staff to add charges to it for free. When you do so, that staff gains a number of charges equal to the highest level of spell you’re able to cast. […] You can prepare a staff only if you have at least one of the staff’s spells on your spell list.

The question is, how many charges does the staff gain? One charge, because they can only cast first-level spells from the spell list that lets them use and prepare the staff? Or two charges, because they are strictly able to cast second-level spells?

Follow-up question: What if they didn’t have Basic Wizard Spellcasting?

Ubuntu 18.04 Does Not Accept “\” or any other appropriate character in paths

I have just installed Ubuntu 18.04 on a former Windows 7 laptop. When trying to connect a printer belonging to a Windows computer on my network through Samba, I find I cannot insert spaces into the path using the usual special character prefixes; the special characters do nothing to the input line. I have already achieved this printer link from my other Ubuntu laptop, which runs an earlier version of Ubuntu.

So has something dramatically changed with 18.04? or am I doing something wrong?

Any help will be appreciated.

Can a character who casts Shapechange and turns into a spellcaster use innate spellcasting to cast spells with a long casting time?

Can a character who casts Shapechange and turns into a spellcaster use innate spellcasting to cast spells with a long casting time?

A specific example is when a druid casts Shapechange to turn into a Planetar that has innate spellcasting. They then cast the Commune spell that Planetars can cast 1/day. The problem is, Commune has a casting time of 1 minute, and Shapechange is a concentration spell.

On pg. 202 of the PHB under “Longer Casting Times”, it states:

When you cast a spell with a casting time longer than a single action or reaction, you must spend your action each turn casting the spell, and you must maintain your concentration while you do so.

I’m wondering if the spellcasting being innate changes that in some way.

Are there any rules or guidelines for large character races?

I’m designing some custom races for my campaign and I’d like to allow large size characters. It seems that large characters are discouraged for some reason and although I’d like to know why what’s more important is finding some official rules or guidelines on how to create large character races like minotaurs, half-ogres, centaurs, etc.

Can a character take on additional backgrounds, or at least their benefits?

Can a character take on additional backgrounds, or at least their benefits?

For example, there is a sorcerer character that has the Charlatan background. This sorcerer happens to be Drow and in an adventure he comes across the Bregan D’aerthe and they recruit him. This would essentially make him a faction agent. So would the character then benefit from the Charlatan background as well as any features the Faction Agent background offers, but without the Faction Agent backstory?

I am asking as the DM.

How Viable is a Sorcerer/Fighter character? [on hold]

I have created a new character for a D&D 5th edition game, and I wanted to ask the community if they thought it would work well.
(My design is based on the main character in a book that I am writing, so much of it is more flavor than trying to create the most optimal build.)

My character was put into this world through a portal that had sucked him out of his world and into this one. His main goal is to return to his home, and by adventuring and gaining experience he could find a way to go back.

The fighting experience came from one of his friends in his old world, and his magic came from his bloodline that could be traced all the way until his ancestor, the older brother who was the king of Eriness.

I need my character to reach 4th level in Fighter, and at least 6th level in Sorcerer.

Weston Teneron
Fighter (Samurai) 3 / Sorcerer (Divine Soul) 1
Adjusted Outlander Background

DEX 16
CON 14
INT 10
WIS 12
CHA 16

AC 16 (Studded Leather Armor / Defense Fighting Style)
Uses Rapier / Longbow


Spare the Dying

1st Level:
Cure Wounds
Guiding Bolt
Shield of Faith

The rest of my party is made of 3 other spellcasting classes (wizard, another sorcerer, druid), a barbarian, a tempest cleric, and a rogue. The campaign is expected to run until 15th level, and is set in the Waterdeep setting.

What I am asking for advice on feats, ability score increases, or spells that I should take. I am entirely new to spellcasters, only dabbling in paladins, fighters and rogues.